EXCEL 如何使用VBA做超链接?答:+1),"")所有版本通用:=IF(ISERROR(MID(A1,FIND("丝,",A1),FIND("个",A1,FIND("螺丝,",A1))-FIND("螺丝,",A1)+1)),"",MID(A1,FIND("螺丝,",A1),FIND("个",A1,FIND("螺丝,",A1))-FIND("螺丝,",A1)+1))。(1)用函数可以办到,假设A1对应“张三:50分”,A2对应“...
excel截取字符答:在B1 、C1 、D1 、 E1 中分别输入:=MID(A1,FIND("A.",A1),FIND("B.",A1)-FIND("A.",A1))=MID(A1,FIND("B.",A1),FIND("C.",A1)-FIND("B.",A1))=MID(A1,FIND("C.",A1),FIND("D.",A1)-FIND("C.",A1))=MID(A1,FIND("D.",A1),999)然后选择这4个单元格...